Setting up and managing health plan budgeting

With the Health Plan product for Axiom Budgeting, your organization can budget health plan and insurance costs by calculating revenues and expenses based on Membership Per Member Per Month (PMPM) calculations. You can then use this information to determine the profitability of each health plan and/or insurance product.

Complete the following steps to configure and budget health plans and insurance products in your organization:

NOTE: As you add or retire plans each year, you will need to complete these steps.

1. Update the LOCATION, INSCODE, and DATATYPE dimension tables.
2. Configure user access and the data filter in the HealthPlan column of the Budget Security Update utility.
3. Add or edit plans and the corresponding actual account data into the ACT_HP_20XX table.
4. Configure the Membership Enrollment Trend driver.
5. Configure the Membership Per Member Per Month (PMPM) driver.
6. Open the HealthPlan Operations utility.